🔍 Query Optimization - emschwartz · Scour

Not all index scans are equal: How we cut query latency by over 99% 📊Database Profiling

datadoghq.com·4d·Hacker News

A Guide for Advanced SQL Joins: ASOF, SEMI, and ANTI joins in ClickHouse 📇Index Selection

glassflow.dev·14h·r/programming

Decoupling Vector Data and Index Storage for Space Efficiency 🗂️Vector Indexes

arxiv.org·2d

How AI Writes SQL for You 🔄SQL Transpilation

pub.towardsai.net·23h

STARBURST ENTERPRISE PERFORMANCE TUNING 📊Database Benchmarking

tshasankda.substack.com·5d·r/programming

Indexing Your Way into a Performance Bottleneck 📇Index Selection

tigerdata.com·4d

Pre-Compiled Filter Sets and Query-Time Specialization in Temporal Databases 🌸Bloom Filters

blog.minns.ai·6d·r/rust

Introducing Metrics SQL: A SQL-based semantic layer for humans and agents 📊Database Profiling

rilldata.com·6d·Hacker News

Mycelium-Index: A Streaming Approximate Nearest Neighbor Index with Myelial Edge Decay, Traffic-Driven Reinforcement, and Adaptive Living Hierarchy 🔍Vector Search Algorithms

arxiv.org·1d

Multi-Region Database Architecture: Three Patents on SQL Abstractions, Data Placement, and Locality-Aware Query Planning ⚙️Database Internals

cockroachlabs.com·6d

QueryData helps agents turn natural language into queries for AlloyDB, Cloud SQL and Spanner 💾Databases

cloud.google.com·4d

TACO: A Benchmark for Open-Domain Text-to-SQL with Ambiguous and Cross-Database Queries 🔄SQL Transpilation

vldb.org·4d

Building a Text-to-SQL Agent with DuckDB, MotherDuck and LangChain 💾Databases

motherduck.com·5d·r/Python

gmr/pgfmt: A PostgreSQL specific SQL statement formatter 💾Databases

github.com·6d·Hacker News

Tool: SQLite Query Result Formatter Demo 💾Databases

simonwillison.net·3d

melihbirim/csvql: SQL queries for CSV files. Ultra-fast CSV query engine in Zig with SIMD parsing and parallel execution. CLI: csvql. 🗄️libSQL

github.com·3d·Hacker News

nickswami/dasein-python-sdk: Dasein managed vector index service - Python SDK 🔎Meilisearch

github.com·4d·Hacker News

Timeseries indexing at scale 📊Database Profiling

datadoghq.com·3d

SynQL: A Controllable and Scalable Rule-Based Framework for SQL Workload Synthesis for Performance Benchmarking 🔧Database Tuning

arxiv.org·5d

AV-SQL: Decomposing Complex Text-to-SQL Queries with Agentic Views 🔄SQL Transpilation

arxiv.org·6d

Loading more...